Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Solved! Aaaaaaggghhhhh! Solvd this myself . . .
This was due to the source data being formatted as currency. The Paste values was pasting it with the currency symbol, hence it was formatted as text in the summary document. So, I changed the format in the source doc to be numbers (not currency) and Hey! Presto! it works a treat. Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number stored as text | Excel Worksheet Functions | |||
Number stored as text | Excel Discussion (Misc queries) | |||
Number Stored as Text. | Excel Programming | |||
Number stored as text | Excel Discussion (Misc queries) | |||
Number stored as text | Excel Discussion (Misc queries) |