Shouldn't a stone to flesh scroll make a stone golem into a flesh golem? he he

Yes, but only for a short time.

Does it actually do it? I tried it but it didn't seem to work....

Now that's a funny thing to try :D .

It would be so cool if it worked...

I've never tried it because it is only for one round. This is from the MM.

Combat: Greater golems are mindless in combat, only following the simple tactics of their masters. They are completely emotionless and cannot be swayed in any way from their instructions. They will not pick up and use weapons in combat, even if ordered to, always preferring their fists. Stone golems have a strength of 22, for purposes of breaking or throwing things.
The stone golem is immune to any weapon, except those of +2 or better enchantment. A rock to mud spell slows a golem for 2-12 (2d6) rounds. Its reverse, mud to rock acts to heal the golem, restoring all lost hit points. A flesh to stone spell does not actually change the golem's structure, but does make it vulnerable to any normal attack for the following round. This does not include spells, except those that will cause direct damage. All other spells are ignored. Once every other round, the stone golem can cast a slow spell upon any opponent with 10 feet of it.

I actually tested this on the Golems in the de'Arnise Keep; after Lowering their Magic resistance, I cast Flesh to Stone on a Flesh Golem, which Petrified it, and Stone to Flesh on a Stone Golem, which had no effect at all.