I am using an excel spreadsheet to enter details into a word document, but even though a cell is formatted in currency format when I use the following code....
appWD.Selection.MoveDown Unit:=wdLine, Count:=4
appWD.Selection.MoveLeft Unit:=wdCharacter, Count:=2
appWD.Selection.TypeText Text:=strReference
The text changes from £33.50 in the Excel spreadsheet to 33.5 in the Word document, any tips?
Bookmarks