LinkBack URL
About LinkBacks
If I have cell A2 as 0001.00 (001000100) 00000
What would be the best formula to get a result of 0010001.00 Taking the number in the brackets while adding a "." before the last two numbers.
Thanks
If I have cell A2 as 0001.00 (001000100) 00000
What would be the best formula to get a result of 0010001.00 Taking the number in the brackets while adding a "." before the last two numbers.
Thanks
If you want the number value:
Formula:
Please Login or Register to view this content.
Or as text:
Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Great the text outcome is exactly what I was looking for thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks