hi
how can I write a formula in a cell that after calculate convert to text, without VBA!
hi
how can I write a formula in a cell that after calculate convert to text, without VBA!
Hi,
welcome to the forum, you can display formula's by using keyboard shortcut/toggle Ctrl+`
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
tanx! but I need an auto way to do it without using VBA (if possible!)
Don't think you can do that without VBA?
Maybe
Ctrl + H > Find box enterand replace box enter=then replace all'=
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Of course you can Tools >Options > Formulas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks